home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
ShareWare OnLine 2
/
ShareWare OnLine Volume 2 (CMS Software)(1993).iso
/
finance
/
tinym215.zip
/
TINY.DOC
< prev
next >
Wrap
Text File
|
1993-01-09
|
129KB
|
2,100 lines
t
███████████░ ██░ ██░ ███░ ██░
██░ ███░ ███░ ███░ ██████░
██░ ██░ ██░ ██░██░ ██░ ████░ ████░ ██░ ██░ ██░ ████ ██░ ███░
██░ ███░ ██░██░ ██░ ██░████ ██░ ████░ ████░ ██░ █░ ██ ████░
██░ ██ ████░██░██░ ██░ ██░ ██░ ██░██░ ██░ ████ ██░ █████ ██░
██░ ██░ ██░████░██░ ██░ ██░ ░░ ██░██████░ ███░ ██░ █░ ██░
██░ ██░ ██░ ███░ ███████░ ██░ ██░██░ ██░ ███░██░ █████░██░ TM
░░ ░░ ░░ ░░░ ██░ ░░ ░░ ░░ ░░ ███░ ░░ ░░░░░ ░░
███░ ███░
██░
Truly INtegrated inventorY V.2.15+
Release as of: 25 Oct 1992
Copyright (c) 1990-1993 by Software Mission Co., Ltd.
Written by Somyos Kiratiwongsakul and Jirayu Wiriyaphibool (The Turbo Team)
┌──────────────────────────────────────────────────────────────────────────────┐
│ Tiny Master is a shareware product. If you find it useful and use it │
│ regularly please send payment support of US$50.- to: Jirayu Wiriyaphibool │
│ Software Mission Co.,Ltd. Micro Source Plaza 629/3 Sathupradit Road, Yannawa │
│ Bangkok 10120 Thailand. Registered user will receive updated versions and │
│ support directly from the authors. Tel: 476-6787 Fax: 476-6781 Telex:84918 │
│ FAST, PRACTICAL AND RELIABLE SOFTWARE THAT GETS YOUR JOB DONE │
└──────────────────────────────────────────────────────────────────────────────┘
HARDWARE REQUIREMENT
COMPUTER SYSTEM: IBM-PC/XT/AT PS2 OR COMPATIBLES
OPERATING SYSTEM: DOS Version 2.0 and Up
STORAGE DEVICES: Hard disk would be recommended for serious use.
DISPLAY ADAPTER: VGA Color or VGA Monochrome
PRINTER: Any Epson compatible, 132 Column printer.
┌─────────────────┐
│Registration form│
└─────────────────┘
Name:________________________
Address:________________________________________
________________________________________
________________________________________
Tel:_____________ Fax:_______________
Computer Brand:_________________
Video Mono( ) VGA Mono( ) VGA Color( )
RAM Memory:_________ Hard disk ______ MB
Dos Version: _______ Printer:______________
Nature of Business:_______________________________________
How many inventory items in your warehouse ? :_______________
Some of the things I need to see in next version are:
1)______________________________________________________________________
2)______________________________________________________________________
3)______________________________________________________________________
Some of the things that should be maintained or enhanced in next version are:
1)______________________________________________________________________
2)______________________________________________________________________
3)______________________________________________________________________
How did you learn about Tiny Master:________________________________
Where did you obtain Tiny Master:_____________________________
Address:_____________________________
_____________________________
_____________________________
*** Please make check or oversea draft payable to: Jirayu Wiriyaphibool. ***
Send all correspondence to: Jirayu Wiriyaphibool
Software Mission Co., Ltd.
Micro Source Plaza
629/3 Sathupradit Road
Yannawa, Bangkok 10120
Thailand.
MESSAGES FROM THE AUTHORS
Tiny Master is a shareware product. This allow you, the user, to
check the program to see if it can be applied and use in your organization.
Software Mission Co., Ltd and Jirayu Wiriyaphibool retains all the rights
to the software. If you find it useful and use it regularly, please register
by sending support payment of US $50 so our team can stay active to maintain
and enhance the program to fit your need.
Registered user will receive:
1) Full technical support for as long as you use our software.
2) Two update diskettes to future release version (Major release).
3) Additional software utility disk to help you work better.
4) Stamps from Bangkok are nice too (If you are a stamp collectors,
this alone would worth the price of registrations.).
Tiny Master was released in 1989 for the sake of testing the shareware
market to see if it is workable. Shareware is better than commercial software
as you can try the program to see if it really fits your need before deciding
to purchase (Register) it.
The original program is written in Turbo Pascal (TM) (Borland Int.) version
3.0. which had quite a few registers. After a three weeks crash-course in
Turbo-C in the University of Tennessee (Knoxville), I have met a new partner,
Somyos, and new back again with a new release of the same program in Turbo
C. The program now uses Btrieve as a file manager so it can be put to a real
serious use. We want to thank all registered users who has given us monetary
and informational support to make the package what it is today. In the future
version, we will break the program into a smaller functional units that will
work faster, consume less memory and had most of the features request by our
users.
At this time, we are unable to supply printed manual due to unlimited funds
and our software continue to update almost every week. We intended to use
registration fees and payment support from user to acquire more programmers at
this moment. These programmers would help extended Tiny Master into other area
such as general ledger, account receivable and payable, production control. Of
course, some part of the money would go to into oversea FAX answering cost and
postage cost which is ridiculously charged by Thai government.
Jirayu Wiriyaphibool
(Owner & Programmer)
INVENTORY CONCEPT
Tiny Master allows you to automatically manage your inventory data, both
quantity and value accounting, while you performing your daily routine works
such as: issuing commercial invoices, writing up purchase orders, preparing
receiving reports, recording customer bookings. The program provides real
time data update so that total inventory information remains active ,current
and reliable.
FEATURES
■ Easy to use, organized pull-down menu and pick lists for easy access
to database information.(Everything is there in one roof)
■ Handle unlimited inventory items, customers, vendors or suppliers,
purchase orders, invoices, stock cards..etc.
■ Provides variable length records to save you valuable disk space and
gives you faster access time.
■ Utilizes the speed and data integrity of Btrieve database manager so
it is truely viable and safe for business use.
■ Uses FIFO (First-in,First-Out) costing and average cost which provide
true cost break-down analysis for each inventory items.
■ Function in real-time mode so your valuable data is always fresh. A
fantastic domino-effect feature provide database consistency
throughout the application with automatic journaling for recheck. For
example: Corrections in receiving report quantity will automatically
adjust purchase order balance and in turn re-adjust the inventory
status.
■ Uses virtual, scrollable screen which emulate real-life document makes
it more practical to use than the usual menu-submenu driven type
application.
■ Built-in database query feature lets you see and set criteria for
filtering and tabulizing data in a more meaningful ways, an effective
tools for management decisions.
■ Comes with all essential inventory reports with wide variety of printing
options that can be printed out at anytime.
TINY MASTER INSTALLATION
To install from drive A: to drive C: Type in:
INSTALL [ENTER]
Then, enter original drive and desination drive and directory and press
F10 to start installation.
TO RUN TINY MASTER
Jump into directory name "Tiny" type in:
CD \TINY [HIT ENTER]
To run program, type in:
TINY [HIT ENTER]
┌─>≡ Database Transaction Process Report Setup Quit
│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
│░░░░░░░░░░░░░░░░░░░░░░░(Canvas background area)░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
│Access to database information <─────────┐
│ │
└───── Pull down menu selection. └── Status & Hot Key Line
PROGRAM OVERVIEW
Tiny Master's screen is divided into three parts. On top of the screen will
be a list of pull down menu selection. In the middle of the screen will be
canvas area where your actual data window will appear. The last bottom line on
the screen will be a status line which explains each menu topic.
MAIN MENU SELECTION AND MANOUVERING
You can select the main menu item in two ways:
■ Simply use the left and right <- -> arrow key to move the reverse bar
to the item of your choice and hit [ENTER] Key
OR
■ Hit the first highlight letter of each menu item. In this case, D would
be for Database, T for Transaction, P,R,S,Q and so on.
≡ Database Transaction Process Report Setup Quit
░░░░░░┌──────────────────┐░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░│ Inventory │░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░│ Group/Categories │░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░├──────────────────┤░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░│ Customer │░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░│ Vendor/Supplier │░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░└──────────────────┘░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
Access to inventory file
If you select any item, the menu then would drop. (Hence, the name pull
down menu). You now then has more choice selections. Simply use the arrow keys
to move around in four directions to select the item of your choice. (**
PLEASE MAKE SURE THAT SCROLL LOCK KEY IS TURNED OFF, OTHERWISE YOU WILL BE
MOVING THE ENTIRE MENU OR SCREEN INSTEAD OF SELECTING THEM **)
HERE IS THE TOTAL MENU LAYOUT FOR TINY MASTER
≡┌──>Database Transaction Process Report Setup Quit
░░░░│░┌──────────────────┐░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░│░│ Inventory <──────┼──────────────────┐░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░│░│ Group/Categories<┼───────────┐░░░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░│░├──────────────────┤░░░░░░░░░░░│░░░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░│░│ Customer <───────┼────┐░░░░░░│░░░░░░└───── (B)░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░│░│ Vendor/Supplier<─┼─┐░░│░░░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░│░└──────────────────┘░│░░│░░░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░│░░░░░░░░░░░░░░░░░░░░░░│░░│░░░░░░└──────────── (C)░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░│░░░░░░░░░░░░░░░░░░░░░░│░░│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░│░░░░░░░░░░░░░░░░░░░░░░│░░│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░└───(A)░░░░░░░░░░░░░░░░│░░└─────────────────── (D)░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░└────────────────────── (E)░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
Access to inventory file
All Tiny Master program module would always has following format.
(A) is your database topics.
This is the area for keeping permanent data. The word "permanent" in this
case would mean that the data you entered will stay there in the file
until you deliberately "delete it" one by one.
Database Topics are sub divided into four databases of:
(B) Inventory, (C) Group/Categories/ (D) Customer (E) Vendor/Supplier
(B) Inventory is the database of your inventory items.
(C) Group database is used to divide your inventory items into groups
such as Grocery items, Household merchandise, Chemical...etc..
(D) Customer file and listing.
(E) Vendor and Supplier information file.
≡ Database Transaction Process Report Setup Quit
░░░░░░░░░░░░░░░░░░┌────────────────────┐░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░│ Purchase order <───┼──────────────────────(B)░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░│ Receiving report <─┼──────────────────────(C)░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░├────────────────────┤░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░│ Order entries <────┼──────────────────────(D)░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░│ Commercial invoice<┼──────────────────────(E)░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░│ Shipment analysis<─┼──────────────────────(F)░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░└────────────────────┘░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
Write up purchase order
Transaction items is for non-permanent documentary data such as: Purchase
Order, Sales Invoice, Order entries (Customer Booking)..etc. These database
information tends to be erased or cleared at specific period (1 or 2 months or
so). Of course, you might keep it for future reference but that would waste
valuable hard disk spaces. Tiny Master allows you to reset or erased these
transaction data for item that has been completed or no longer useful.
Transaction topic consist of:
(B) Purchase order - For writing purchase order to be send to your
supplier or vendors.
(C) Receiving Report - When goods are received according to your
purchase order, uses receiving report to track your purchases and
automatcally updated your inventory.
(D) Order Entries - This is where you will enter pre-order or
booking from your customer.
(E) Commercial Invoice - When you are ready to ship goods to customer,
simply generate sales invoice to your customer by writing it up or pull
it from (Order Entries)
(D). (F) Shipment Analysis - Let you see how customer orders are
catching up on your product. Who has ordered them ?. How much quantity
do you need to replace or stock in advance ?
≡ Database Transaction Process Report Setup Quit
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░┌───────────────────────┐░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░(A)─────────>│ End of period │░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░(B)─────────>│ Year-end closing │░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░(C)─────────>│ Transaction clearance │░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░└───────────────────────┘░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
Perform inventory closing for selected period NUM INSERT
Process menu allows you to reset and process your inventory for the end
of each inventory period. You will finish printing all your require reports
before choosing this menu.
(A) End of Period. Tiny Master counts your inventory period by numbers. So
you can close down your inventory period to reflect the company inventory
cycle which can be per day, per week, per month, per quarters or even per
year. All accumulated information for each inventory item will be cleared and
the ending balance, both quantity and value, will be moved to next inventory
period.
(B) Year-end closing. This menu will be select at the end of a year. It
simply clears all accumulated information for all inventory periods and
reset it for the beginning of next year.
(C) Transaction clearance. This menu allows you to clear all unused
documents such as purchase orders, Invoices, Receiving reports which are no
longer useful and have already been processed. This will leave more rooms in
you disk spaces to store addtional document data that would come up later. If
you want to keep past invoices, purchase orders for a yearly review, you will
simply ignore this options.
≡ Database Transaction Process Report Setup Quit
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░┌─────────────────────┐░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░(A)────────────────┤ Inventory listing │░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░(B)────────────────┤ Dead-stock listing │░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░(C)────────────────┤ Reorder listing │░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░(D)────────────────┤ Overstock listing │░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░(E)────────────────┤ Price list │░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░├─────────────────────┤░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░(F)────────────────┤ Physical inventory │░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░(G)────────────────┤ Inventory valuation │░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░(H)────────────────┤ Yearly summary │░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░├─────────────────────┤░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░(I)────────────────┤ Receiving │░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░(J)────────────────┤ Sales/Distribution │░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░(K)────────────────┤ Outstanding order │░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░└─────────────────────┘░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
Print out onhand quantity CAPS NUM
(A) Inventory listing.
≡ Database Transaction Process Report Setup Quit
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░┌──────────────────────┐░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░(A)────────────────────>░│ Create database file │░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░(B)────────────────────>░│ Company profile │░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░└──────────────────────┘░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
Create all system database files
Tiny Master comes with 50 inventory items as an example. You can play
around with these existing data to understand some of the concepts that has
been put into this software. When you're ready to start your own inventory
information, simply select (A) create database file to initialize or reset
database. All information about inventory will be cleared and you are ready to
enter your own information.
SETTING UP DATABASE (FOR YOU OWN USE)
Tiny Master sometimes come with no sample data. So the system has no
data file and you had to create it before using.
WARNING: ALL EXISTING DATA IN THE SYSTEM WILL BE TOTALLY CLEARED. YOU
SHOULD BE VERY CAREFUL WHEN USING THIS OPTION.
≡ Database Transaction Process Report Setup Quit
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░┌─────────────────┐░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│ Create database │░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│ Company profile │░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░└─────────────────┘░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░╔╤══════════════════════════════╗░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░╟┘ Create Database Files ║░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░╟───────────────────────────────╢░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░║ Do you want to continue? ║░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░║ ┌──────────╖ ┌───────╖ ║░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░║ │ CONTINUE ║ │ ABORT ║ ║░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░║ ╘══════════╝ ╘═══════╝ ║░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░╚═══════════════════════════════╝░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
Create all system database files NUM
Press C to firm create database or press A to abort.
≡ Database Transaction Process Report Setup Quit
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░┌─────────────────┐░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│ Create database │░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│ Company profile │░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░└─────────────────┘░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░╔╤════════════════════════════════════════════╗░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░╟┘ Verify ║░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░╟─────────────────────────────────────────────╢░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░║ Please select CONTINUE to confirm operation ║░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░║ ┌──────╖ ┌──────────╖ ┌───────╖ ║░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░║ │ EXIT ║ │ CONTINUE ║ │ ABORT ║ ║░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░║ ╘══════╝ ╘══════════╝ ╘═══════╝ ║░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░╚═════════════════════════════════════════════╝░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
The program will let you confirm one more time and then will reset
databases size to their initial size (extremely blank).
ENTERING COMPANY PROFILE
For the first time when you start Tiny Master, you will need to select
[Company profile] option to enter information about your company. This
company profile will be used as heading label for all your document such as
Purchase Order, Invoice and also appear on your reports. You will also have
to specify default sales tax rate for the system. When complete filling all
the data, press F10 to save to disk or ESC to cancel.
≡ Database Transaction Process Report Setup Quit
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░┌─────────────────┐░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│ Create database │░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│█Company█profile█│░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░└─────────────────┘░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░╔╤════════════════════════════════════════════════════════════════════╗░░░░░
░░░░╟┘ Company profile ║░░░░░
░░░░╟─────────────────────────────────────────────────────────────────────╢░░░░░
░░░░║ ║░░░░░
░░░░║ Company Name: Mission Mart Inc. ║░░░░░
░░░░║ Full Address: 629/3 Sathupradit Road ║░░░░░
░░░░║ Yannawa, Bangkok 10120 Thailand ║░░░░░
░░░░║ Tel. & Fax. No.: (444)-4524 (344)523-4523 (333)452-3452 ║░░░░░
░░░░║ Sales Tax Rate: 7.00% ║░░░░░
░░░░║ Note: memo ┌╢░░░░░
░░░░╚════════════════════════════════════════════════════════════════════╧╝░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
Company profile record NUM
GETTING START (STEP BY STEP ILLUSTRATION)
The first thing when using your inventory program is to count your physical
inventory and input all informations once into the database.
≡ Database Transaction Process Report Setup Quit
░░░░░░┌──────────────────┐░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░│ Inventory │░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░│ Group/Categories │░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░├──────────────────┤░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░│ Customer │░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░│ Vendor/Supplier │░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░└──────────────────┘░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
Access to inventory file
Select [Database] topic and [Inventory] to access to inventory information.
┌──────TRAVELING MENU
│
Append Delete Update Next Previous Top Bottom Search Order View Exit
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░╔╤════════════════════════════════════════════════════════════════════╗░░░░░
░░░░╟┘ Inventory Database File ║░░░░░
░░░░╟─────────────────────────────────────────────────────────────────────╢░░░░░
░░░░║ Item Code#: ║░░░░░
░░░░║ Description: ║░░░░░
░░░░║ Group Code: ║░░░░░
░░░░║ Group Name: ║░░░░░
░░░░║ Unit Count: ║░░░░░
░░░░║ Cost/Unit: Selling Price: ║░░░░░
░░░░║ Minimum QTY.: Maximum QTY.: ║░░░░░
░░░░║ Beginning QTY.: Beginning Value: ║░░░░░
░░░░║ Onhand QTY.: Onhand Value: ║░░░░░
░░░░║ Warehouse: Note: memo ║░░░░░
░░░░║ ┌╢░░░░░
░░░░╚════════════════════════════════════════════════════════════════════╧╝░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
F1:Help F2:Pick List F3:Stat F4:FIFO F5:Ledger F10:Confirm Esc:Cancel Alt-M:Memo
│Append a new record to database file────┐ NUM
│ │
│ │
└───── HOT KEY MENU └──── COMMENT LINE
TRAVELING MENU
Traveling menu lets you manipulate, jump, search, or walk back and forth
inside a database. You can select the menu by hitting the first highlight
character of each word or simply move the reverse bar to that item and hit
[ENTER] key.
Each item in traveling menu can be explained as following.
Append - Add new, non-existing item into the database.
Delete - Delete that item on screen.
Update - Edit or change existing data.
Next - Walk to next inventory item base on selected order key.
Prev - Walk to previous inventory item base on selected order key.
Top - Jump to first inventory item base on selected order key.
Bottom - Jump to last inventory item base on selected order key.
Search - Search for inventory item base on key.
Order - Set the order key.
View - View or browse inventory item with and without conditions.
Exit - Get out of Traveling menu and back to previous menu.
ADDING NEW INVENTORY ITEMS
The first thing to do is to feed in as much as possible all the inventory
items into the database.
■ Select [Append] command by highlight the word "Append" and hit ENTER or
hit "A" character.
Here are some of the items you will need to enter.
Item Code#:
Item Code is a unique inventory code that represents an item. It can be up
to 17 characters in length and can contain both numbers and alphabets. Using
shorter item code will comsume less disk space as Tiny Master utilizes
variable length records. When you add a new item, the program automatically
checks for duplicate code. ** REMARKS ** While in each blank fields, you can
also press F1 for help information on how to jump and move around entering
data.
Description:
Description is simply the full description of your products. Again shorter
description will consume less disk space as Tiny uses variable length to store
the record.
Group Code:
Group code organizes your inventory into group such as: Finish Goods, Raw
materials, Chemicals, Electronics items...etc. Breaking down inventory by
group allows you to produce various reports break down by group. Sometimes,
you can search an item by group when you can not remember an exact code or the
full description. Group code should be short and meaningful. Here is an
example of good group code selected from our users.
Group code Group Name it represents
0162-1 - This is what!!!!!??????
ELEC - Electronics and gadgets.
MAT - Raw materials
FIN - Finish goods
CHEM - Chemical and compounds.
WIP - Work in process items.
If the group code you specify doesn't yet exist in the database, Tiny will
pop up a window and request you to define new group.
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░╔╤════════════════════════════════════════════════════════════════════╗░░░░░
░░░░╟┘ Inventory Database File ║░░░░░
░░░░╟─────────────────────────────────────────────────────────────────────╢░░░░░
░░░░║ ╔╤════════════════════════════════════════════════════════╗ ║░░░░░
░░░░║ ╟┘ Group/Categories Database File ║ ║░░░░░
░░░░║ D╟─────────────────────────────────────────────────────────╢ ║░░░░░
░░░░║ ║ ║ ║░░░░░
░░░░║ ║ Group Code: CHEM ║ ║░░░░░
░░░░║ ║ Group Name: Chemical and compounds ║ ║░░░░░
░░░░║ ║ Note: memo ║ ║░░░░░
░░░░║ Mi║ ┌╢ ║░░░░░
░░░░║ Begi╚════════════════════════════════════════════════════════╧╝.00 ║░░░░░
░░░░║ Onhand QTY.: 0.00 Onhand Value: $0.00 ║░░░░░
░░░░║ Warehouse: Note: memo ║░░░░░
░░░░║ ┌╢░░░░░
░░░░╚════════════════════════════════════════════════════════════════════╧╝░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
You can simply add new group code and group name then press F10 to save to
file or hit ESC to cancel.
If the group code is already exist in the database, simply hit F2 in
group code field to pick from the list of group name.
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░╔╤════════════════════════════════════════════════════════════════════╗░░░░░
░░░░╟┘ Inventory Database File ║░░░░░
░░░░╟─────────────────────────────────────────────────────────────────────╢░░░░░
░░░░║ ║░░░░░
░░░░║ I┌─────────────────────────────────────────────────────┐ ║░░░░░
░░░░║ De│ Group Code Group Name │ ║░░░░░
░░░░║ G├─────────────────────────────────────────────────────┤ ║░░░░░
░░░░║ G│█ELEC███████Electric Appliance███████████████████████│ ║░░░░░
░░░░║ U│ LADIES Ladies Apparel │ ║░░░░░
░░░░║ │ SNACKS SNACKS ITEM │20 ║░░░░░
░░░░║ Min│ TOYS Toys & Gimmick section │0 ║░░░░░
░░░░║ Begin│ │$22.50 ║░░░░░
░░░░║ On│ │128.25 ║░░░░░
░░░░║ └─────────────────────────────────────────────────────┘ ║░░░░░
░░░░║ ┌╢░░░░░
░░░░╚════════════════════════════════════════════════════════════════════╧╝░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
Group Name:
Group Name will be automatically pulled from group definition database.
Unit count:
Unit count is the volume count of inventory item such as: KGS, EA, PCS,
BOX ...etc. It is better to use abbreviation for this field as it will take up
less disk space and save some typing time as Tiny keeps your data as variable
length. What you did not type in did not cost you anything?
Cost/Unit:
Cost per unit is the cost per unit count mentioned above. If an inventory
item has many cost per quantity, you will need to estimate the cost or average
it out. Tiny Master will later use FIFO (First-in,First-Out) cost and maintain
incoming cost for you.
Selling Price:
Selling Price is the selling price per unit count mentioned above. The
selling price is not fix or static as you can change it later inside the
applcation when you issue invoices.
Minimum Qty:
Minimum quantity is where you will set lower quantity limit for the item.
The program will flag a lower-than-minimum warning when the quantity gets
below this level. This is simply an understock warning.
Maximum Qty:
Maximum quantity is where you will set upper quantity limit for the item.
The program will flag an over-than-maximum warning when the quantity gets
above this level. This is simply an overstock warning.
Beginning Qty:
Beginning quantity is the starting or beginning physical quantity for the
period. If your inventory period is on a monthly basis, you will need to put
physical quantity count on 1st day of that month in this field.
Onhand Qty:
Since there is no transaction occured in your system yet, the onhand
quantity would be equal to the Beginning quantity above.
Warehouse:
Tiny Master allows you to assign warehouse number or name to an item. This
allows you to provide breakdown report by warehouses in both cost and
quantity. The warehouse field should be ignored if you have only single
warehouse. Warehouse number can also be used for outlet or showroom so that
clerks can control quantity and value assigned to each site-location. Some
company that has organized warehouse might be able to use this field for
location in warehouse such as E12C-10B, ED122-20B, ED128-19C.
Note:
Note allows you to attach memo information to an inventory item. Press
Alt-M when blinking cursor gets on the word memo to pop up memo window. You
can write anything about inventory item such as specification details, usage
notes and other information in this windows. When finish press F10 to save
memo to disk or ESC to cancel memo. Later in the program you can hit Alt-M
(Traveling menu) to popup memo information.
Press F10 again to save inventory data to disk or hit ESC to abort.
DELETE INVENTORY ITEM
■ Select [Delete] command by highlight the word "delete" and hit ENTER or
hit "D" character.
Append Delete Update Next Previous Top Bottom Search Order View Exit
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░╔╤════════════════════════════════════════════════════════════════════╗░░░░░
░░░░╟┘ Inventory Database File ║░░░░░
░░░░╟─────────────────────────────────────────────────────────────────────╢░░░░░
░░░░║ ║░░░░░
░░░░║ Item C╔╤════════════════════════════════════════════╗ ║░░░░░
░░░░║ Descrip╟┘ Verify ║ ║░░░░░
░░░░║ Group ╟─────────────────────────────────────────────╢ ║░░░░░
░░░░║ Group ║ Do you really want to erase current record? ║ ║░░░░░
░░░░║ Unit C║ ║ ║░░░░░
░░░░║ Cost/║ ┌────────╖ ┌──────────╖ ┌───────╖ ║$1.20 ║░░░░░
░░░░║ Minimum ║ │ DELETE ║ │ CONTINUE ║ │ ABORT ║ ║0.00 ║░░░░░
░░░░║ Beginning ║ ╘════════╝ ╘══════════╝ ╘═══════╝ ║ $22.50 ║░░░░░
░░░░║ Onhand ╚═════════════════════════════════════════════╝ $128.25 ║░░░░░
░░░░║ Warehouse: 1 Note: memo ║░░░░░
░░░░║ ┌╢░░░░░
░░░░╚════════════════════════════════════════════════════════════════════╧╝░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
To confirm delete item, highlight DELETE choice and hit [ENTER] or hit "D"
character, otherwise select CONTINUE and ABORT to cancel deletion. When
inventory item is deleted, disk spaces will be dynamically reclaimed and freed
for other storage uses.
UPDATE OR CHANGE INVENTORY ITEM
■ Select [Update] command by highlighting the word "Update" and hit ENTER
or by hitting "U" character.
■ Followed the same procedure as ADDING NEW INVENTORY ITEMS above to
change data of each fields. When ready, press F10 to save data to disk
or hit ESC to cancel and change the data back to its original value.
NEXT/PREV/TOP/BOTTOM
■ NEXT command allows you to move to next inventory item base on
selected index key; vise versa for PREV command. This four commands NEXT
PREV TOP BOTTOM works in conjunction with ORDER command to browse back and
forth on index key. (See below for ORDER command)
■ TOP command will move you to the first inventory item base on
selected key while BOTTOM command will move you the last record.
ORDER
■ ORDER command allows you to set selected index key in which you will
use to browse through the database.
Append Delete Update Next Previous Top Bottom Search Order View Exit
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░┌─────────────┐░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│ Item Code# │░░░░░░░░░░░░░
░░░░╔╤══════════════════════════════════════════════│ Description │═══════╗░░░░░
░░░░╟┘ Inventory Database File │ Group Code │ ║░░░░░
░░░░╟───────────────────────────────────────────────│ Warehouse │───────╢░░░░░
░░░░║ └─────────────┘ ║░░░░░
░░░░║ Item Code#: 0129 ║░░░░░
░░░░║ Description: Chocho Chips Cookies ║░░░░░
░░░░║ Group Code: SNACKS ║░░░░░
░░░░║ Group Name: SNACKS ITEM ║░░░░░
░░░░║ Unit Count: EA ║░░░░░
░░░░║ Cost/Unit: $0.75 Selling Price: $1.20 ║░░░░░
░░░░║ Minimum QTY.: 0.00 Maximum QTY.: 0.00 ║░░░░░
░░░░║ Beginning QTY.: 30.00 Beginning Value: $22.50 ║░░░░░
░░░░║ Onhand QTY.: 171.00 Onhand Value: $128.25 ║░░░░░
░░░░║ Warehouse: 1 Note: memo ║░░░░░
░░░░║ ┌╢░░░░░
░░░░╚════════════════════════════════════════════════════════════════════╧╝░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
Tiny lets you set order of index by four keys: item code, description,
group code and warehouse. The default or initial index is "item code#" when
you started the program. When you change the order for index key, it remains
with that key until you later change it again in the application. If you
select an index order as "description", the NEXT and PREV command will let you
alphabetically browse back and forth by description, same with Group code and
warehouse.
SEARCHING FOR INVENTORY ITEM
■ Select [Search] command by highlighting the word "Search" and hit ENTER
or by hitting "S" character.
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░┌─────────────┐░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│ Item Code# │░░░░░░░░░░░░░
░░░░╔╤══════════════════════════════════════════════│█Description█│═══════╗░░░░░
░░░░╟┘ Inventory Database File │ Group Code │ ║░░░░░
░░░░╟───────────────────────────────────────────────│ Warehouse │───────╢░░░░░
░░░░║ └─────────────┘ ║░░░░░
░░░░║ Item Code#: 0129 ║░░░░░
░░░░║ Description: Chocho Chips Cookies ║░░░░░
░░░░║ Group Co╔╤═════════════════════════════════════════╗ ║░░░░░
░░░░║ Group Na╟┘ Enter data ║ ║░░░░░
░░░░║ Unit Cou║ ║ ║░░░░░
░░░░║ Cost/Un║ [ ]║ $1.20 ║░░░░░
░░░░║ Minimum QT╚══════════════════════════════════════════╝ 0.00 ║░░░░░
░░░░║ Beginning QTY.: 30.00 Beginning Value: $22.50 ║░░░░░
░░░░║ Onhand QTY.: 171.00 Onhand Value: $128.25 ║░░░░░
░░░░║ Warehouse: 1 Note: memo ║░░░░░
░░░░╚═════════════════════════════════════════════════════════════════════╝░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
Search command lets you search by item code, description, group code, and
warehouse. It also allows partial search so typing only a few leading
characters will get you a closest-match item. After that, you can use NEXT and
PREV command to locate the exact item.
VIEW OR BROWSE DATABASE (DATABASE QUERY)
Press V or select the [View] command to perform database query or just
plain viewing of data in a tabulized form. This option lets you do advance
database query just like commercial packages such as: RBASE, PARADOX,
PROFILE...etc. The database query lets you select everything by using menus.
[View] command can be broken down into three options.
[Execute the command] options allows you to view the entire inventory in a
table form immediately.
Append Delete Update Next Previous Top Bottom Search Order View Exit
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░┌────────────────────────────┐░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░│█Execute the command████████│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░╔│ Specify the command scopes │═══════════════════════════════════════╗░░░░░
░░░░╟│ Specify search conditions │ Database File ║░░░░░
░░░░╟└────────────────────────────┘───────────────────────────────────────╢░░░░░
░░░░║ ║░░░░░
░░░░║ Item Code#: 0129 ║░░░░░
░░░░║ Description: Chocho Chips Cookies ║░░░░░
░░░░║ Group Code: SNACKS ║░░░░░
░░░░║ Group Name: SNACKS ITEM ║░░░░░
░░░░║ Unit Count: EA ║░░░░░
░░░░║ Cost/Unit: $0.75 Selling Price: $1.20 ║░░░░░
░░░░║ Minimum QTY.: 0.00 Maximum QTY.: 0.00 ║░░░░░
░░░░║ Beginning QTY.: 30.00 Beginning Value: $22.50 ║░░░░░
░░░░║ Onhand QTY.: 171.00 Onhand Value: $128.25 ║░░░░░
░░░░║ Warehouse: 1 Note: memo ║░░░░░
░╔══════════════════════════════ View Command ══════════════════════════════╗░░░
░║ View █ ║░░░
░╚══════════════════════════════════════════════════════════════════════════╝░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
Format for viewing is immediately form in a table like form looks like
below:
Append Delete Update Next Previous Top Bottom Search Order View Exit
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░╔╤═══════════════════════════════════════════════════════════════════════╗░░░░
░░╟┘ Database Query ║░░░░
░░╟────────────────────────────────────────────────────────────────────────╢░░░░
░░║┌──────────────────┬──────────────────────────────────────────┬─────────║░░░░
░░║│ Item Code# │ Description │ Group/Ty║░░░░
░░║├──────────────────┼──────────────────────────────────────────┼─────────║░░░░
░░║│ 0129 │ Chocho Chips Cookies │ SNACKS ║░░░░
░░║│ 0130 │ AUNT JAMAIMA LIGHT COOKIES MIX │ SNACKS ║░░░░
░░║│ 0132 │ Coffee Warmer (ElectroLux) ELX-1208P │ ELEC ║░░░░
░░║│ 2091-092 │ Sound Blaster │ ELEC ║░░░░
░░║│ EC1276 │ Electric Calculator 1276 (Texas Inst) │ ELEC ║░░░░
░░║└──────────────────┴──────────────────────────────────────────┴─────────║░░░░
░░╚════════════════════════════════════════════════════════════════════════╝░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
With in the table you can use four-directional arrow keys to scroll the
viewing table around.
When finish viewing, press ESC to come back to original screen.
Append Delete Update Next Previous Top Bottom Search Order View Exit
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░┌────────────────────────────┐░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░│ Execute the command │░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░╔│█Specify the command scopes█│═══════════════════════════════════════╗░░░░░
░░░░╟│ Specify search conditions │ Database File ║░░░░░
░░░░╟└────────────────────────────┘───────────────────────────────────────╢░░░░░
░░░░║ Item Code#: 0129 ║░░░░░
░░░░║ Description: Chocho Chips Cookies ║░░░░░
░░░░║ Group Code: SNACKS ║░░░░░
░░░░║ Group Name: SNACKS ITEM ║░░░░░
░░░░║ Unit Count: EA ║░░░░░
░░░░║ Cost/Unit: $0.75 Selling Price: $1.20 ║░░░░░
░░░░║ Minimum QTY.: 0.00 Maximum QTY.: 0.00 ║░░░░░
░░░░║ Beginning QTY.: 30.00 Beginning Value: $22.50 ║░░░░░
░░░░║ Onhand QTY.: 171.00 Onhand Value: $128.25 ║░░░░░
░░░░║ Warehouse: 1 Note: memo ║░░░░░
░╔══════════════════════════════ View Command ══════════════════════════════╗░░░
░║ View █ ║░░░
░╚══════════════════════════════════════════════════════════════════════════╝░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
The [View] command with [Specify the command scopes] option lets you view
all or part of your database.
Append Delete Update Next Previous Top Bottom Search Order View Exit
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░┌────────────────────────────┐░░░░░┌─────────────────────────────────┐░░░░░
░░░░░│ Execute the command │░░░░░│ All database records │░░░░░
░░░░╔│█Specify the command scopes█│═════│█Start from current to ±N Record█│░░░░░
░░░░╟│ Specify search conditions │ Data│ To the rest of database file │░░░░░
░░░░╟└────────────────────────────┘─────└─────────────────────────────────┘░░░░░
░░░░║ ║░░░░░
░░░░║ Item Code#: 0129 ║░░░░░
░░░░║ Description: Chocho Chips Cookies ║░░░░░
░░░░║ Group Code: SNACKS ║░░░░░
░░░░║ Group Name: SNACKS ITEM ║░░░░░
░░░░║ Unit Count: EA ║░░░░░
░░░░║ Cost/Unit: $0.75 Selling Price: $1.20 ║░░░░░
░░░░║ Minimum QTY.: 0.00 Maximum QTY.: 0.00 ║░░░░░
░░░░║ Beginning QTY.: 30.00 Beginning Value: $22.50 ║░░░░░
░░░░║ Onhand QTY.: 171.00 Onhand Value: $128.25 ║░░░░░
░░░░║ Warehouse: 1 Note: memo ║░░░░░
░╔══════════════════════════════ View Command ══════════════════════════════╗░░░
░║ View █ ║░░░
░╚══════════════════════════════════════════════════════════════════════════╝░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
SPECIFY THE COMMAND SCOPES OPTION CAN BE BREAK DOWN INTO FOLLOWING:
[All database records] option lets you view all just like
Execute the command] option.
[Start from current to N Record] option lets you view record in numbers from
the current item on the screen. This option allows you view forward and backward
in number of records from current item.
[To the rest of database file] option will show you all the record to the
last record in the database starting from the current item.
[Execute the command] option then will let you view a table according to
above specify scopes.
VIEW TABLE WITH CONDITIONS
Append Delete Update Next Previous ┌────────────────────────┐r View Exit
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│ Item Code# │░░░░░░░░░░░░░░
░░░░░┌────────────────────────────┐░░░░░│ Description │░░░░░░░░░░░░░░
░░░░░│ Execute the command │░░░░░│ Group Code │░░░░░░░░░░░░░░
░░░░╔│ Specify the command scopes │═════│ Warehouse │════════╗░░░░░
░░░░╟│█Specify search conditions██│ Data│ Average Cost │ ║░░░░░
░░░░╟└────────────────────────────┘─────│ Selling Price │────────╢░░░░░
░░░░║ │ Beginning QTY. │ ║░░░░░
░░░░║ Item Code#: 0129 │ Beginning Value │ ║░░░░░
░░░░║ Description: Chocho Chips Cooki│ Purchase QTY. │ ║░░░░░
░░░░║ Group Code: SNACKS │ Purchase Value │ ║░░░░░
░░░░║ Group Name: SNACKS ITEM │ Back to Supplier QTY. │ ║░░░░░
░░░░║ Unit Count: EA │ Back to Supplier Value │ ║░░░░░
░░░░║ Cost/Unit: $0.75 S│ Sales/Distribute QTY. │20 ║░░░░░
░░░░║ Minimum QTY.: 0.00 │[Sales/Distribute Value]│0 ║░░░░░
░░░░║ Beginning QTY.: 30.00 Beg│ Claim/Returns QTY. │$22.50 ║░░░░░
░░░░║ Onhand QTY.: 171.00 │ Claim/Returns Value │128.25 ║░░░░░
░░░░║ Warehouse: 1 │ Adjustment QTY. │ ║░░░░░
░╔══════════════════════════════ View Co│ Adjustment Value │══════════╗░░░
░║ View █ │ Ending QTY. │ ║░░░
░╚══════════════════════════════════════│ Ending Value │══════════╝░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│ Cost of Goods Sold │░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│ Gross Margin │░░░░░░░░░░░░░░
└────────────────────────┘
[View] command with [Specify search conditions] option lets you view only
items that meet the search condition or the criteria you are looking for.
Append Delete Update Next Previous Top Bottom Search Order View Exit
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░┌────────────────────────────┐░░░░░┌─────────────────────────────┐░░░░░░░░░
░░░░░│ Execute the command │░░░░░│ = Equal to │░░░░░░░░░
░░░░╔│ Specify the command scopes │═════│ <= Less than or equal to │═══╗░░░░░
░░░░╟│█Specify search conditions██│ Data│ < Less than │ ║░░░░░
░░░░╟└────────────────────────────┘─────│[> Greater than ]│───╢░░░░░
░░░░║ │ >= Greater than or equal to │ ║░░░░░
░░░░║ Item Code#: 0129 │ <> Not equal to │ ║░░░░░
░░░░║ Description: Chocho Chips Cooki└─────────────────────────────┘ ║░░░░░
░░░░║ Group Code: SNACKS ║░░░░░
░░░░║ Group Name: SNACKS ITEM ║░░░░░
░░░░║ Unit Count: EA ║░░░░░
░░░░║ Cost/Unit: $0.75 Selling Price: $1.20 ║░░░░░
░░░░║ Minimum QTY.: 0.00 Maximum QTY.: 0.00 ║░░░░░
░░░░║ Beginning QTY.: 30.00 Beginning Value: $22.50 ║░░░░░
░░░░║ Onhand QTY.: 171.00 Onhand Value: $128.25 ║░░░░░
░░░░║ Warehouse: 1 Note: memo ║░░░░░
░╔══════════════════════════════ View Command ══════════════════════════════╗░░░
░║ View For Sales/Distribute Value █ ║░░░
░╚══════════════════════════════════════════════════════════════════════════╝░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
The menu selection choices will allow you to set conditional search by
picking from the menu with explanation of condition in the View Command window.
Append Delete Update Next Previous Top Bottom Search Order View Exit
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░┌────────────────────────────┐░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░│ Execute the command │░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░╔│ Specify the command scopes │═══════════════════════════════════════╗░░░░░
░░░░╟│█Specify search conditions██│ Database File ║░░░░░
░░░░╟└────────────────────────────┘───────────────────────────────────────╢░░░░░
░░░░║ ║░░░░░
░░░░║ Item Code#: 0129 ║░░░░░
░░░░║ Description: Chocho Chips Cookies ║░░░░░
░░░░║ Group Code: SNACKS ╔╤═══════════════════╗ ║░░░░░
░░░░║ Group Name: SNACKS ╟┘ Enter data ║ ║░░░░░
░░░░║ Unit Count: EA ║ ║ ║░░░░░
░░░░║ Cost/Unit: ║ $ 0.00 ║e: $1.20 ║░░░░░
░░░░║ Minimum QTY.: ╚════════════════════╝.: 0.00 ║░░░░░
░░░░║ Beginning QTY.: 30.00 Beginning Value: $22.50 ║░░░░░
░░░░║ Onhand QTY.: 171.00 Onhand Value: $128.25 ║░░░░░
░░░░║ Warehouse: 1 Note: memo ║░░░░░
░╔══════════════════════════════ View Command ══════════════════════════════╗░░░
░║ View For Sales/Distribute Value > █ ║░░░
░╚══════════════════════════════════════════════════════════════════════════╝░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
Append Delete Update Next Previous Top Bottom Search Order View Exit
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░┌────────────────────────────┐░░░░░┌────────────────────┐░░░░░░░░░░░░░░░░░░
░░░░░│ Execute the command │░░░░░│█No more condition █│░░░░░░░░░░░░░░░░░░
░░░░╔│ Specify the command scopes │═════│ Combine with 'AND' │════════════╗░░░░░
░░░░╟│ Specify search conditions │ Data│ Combine with 'OR' │ ║░░░░░
░░░░╟└────────────────────────────┘─────└────────────────────┘────────────╢░░░░░
░░░░║ ║░░░░░
░░░░║ Item Code#: 0129 ║░░░░░
░░░░║ Description: Chocho Chips Cookies ║░░░░░
░░░░║ Group Code: SNACKS ║░░░░░
░░░░║ Group Name: SNACKS ITEM ║░░░░░
░░░░║ Unit Count: EA ║░░░░░
░░░░║ Cost/Unit: $0.75 Selling Price: $1.20 ║░░░░░
░░░░║ Minimum QTY.: 0.00 Maximum QTY.: 0.00 ║░░░░░
░░░░║ Beginning QTY.: 30.00 Beginning Value: $22.50 ║░░░░░
░░░░║ Onhand QTY.: 171.00 Onhand Value: $128.25 ║░░░░░
░░░░║ Warehouse: 1 Note: memo ║░░░░░
░╔══════════════════════════════ View Command ══════════════════════════════╗░░░
░║ View For Sales/Distribute Value > $300.00 █ ║░░░
░╚══════════════════════════════════════════════════════════════════════════╝░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
Also you can combine many conditions together with .AND. and .OR. options
to form a more complicate query of your database. When finish select [No more
condition] and [Execute the command] to view the table that meet your
criteria. Only records that meet the conditional search or criteria will be
added into virtual table for viewing.
OTHER HOT KEYS
Beside traveling menu, Tiny has hot key for poping up additional information
which relate to the current inventory item shown on the screen.
Press F3 will pop up inventory statistics for that particular inventory item.
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░┌┬────────────────────────────────────────────────────┐░░░░░░░░░░░░░░
░░░░░░░░░░░├┘ Inventory Statistics │░░░░░░░░░░░░░░
░░░░╔╤═════├─────────────────────────────────────────────────────┤════════╗░░░░░
░░░░╟┘ │ Quantity Actual Value │ ║░░░░░
░░░░╟──────│ ┌────────────┬───────────────┬────────────────────┐ │────────╢░░░░░
░░░░║ │ │ Beginning │ 30.00 │ $22.50 │ │ ║░░░░░
░░░░║ I│ ├────────────┼───────────────┼────────────────────┤ │ ║░░░░░
░░░░║ De│ │ Purchase │ 252.00 │ $189.00 │ │ ║░░░░░
░░░░║ G│ │ Rejects │ 0.00 │ $0.00 │ │ ║░░░░░
░░░░║ G│ │ Sales │ 111.00 │ $130.82 │ │ ║░░░░░
░░░░║ U│ │ Claims │ 0.00 │ $0.00 │ │ ║░░░░░
░░░░║ │ │ Adjustment │ 0.00 │ $0.00 │ │20 ║░░░░░
░░░░║ Min│ ├────────────┼───────────────┼────────────────────┤ │0 ║░░░░░
░░░░║ Begin│ │ Ending │ 171.00 │ $128.25 │ │$22.50 ║░░░░░
░░░░║ On│ └────────────┴───────────────┴────────────────────┘ │128.25 ║░░░░░
░░░░║ │ Sales $130.82 │ ║░░░░░
░░░░║ │ - Cost of goods sold $83.25 │ ┌╢░░░░░
░░░░╚══════│ Gross Margin $47.57 │═══════╧╝░░░░░
░░░░░░░░░░░└─────────────────────────────────────────────────────┘░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
Press F4 will pop up FIFO cost table which show cost in break-down, incoming
details. Every inventory item will have up to five level of FIFO cost.
If the incoming lot exceeds 5 levels, Tiny will use average cost as default
calculation. The table cost will automatically adjust itself for every
transaction that occurs.
░░░┌┬──────────────────────────────────────────────────────────────────────┐░░░░
░░░├┘ Cost Break-down information │░░░░
░░░├───────────────────────────────────────────────────────────────────────┤░░░░
░░░│ │░░░░
░░░│ ┌──────────┬──────────┬───────────────┬──────────────────┬──────────┐ │░░░░
░░░│ │ Date │ Doc. No. │ Quantity │ Cost │ Type │ │░░░░
░░░│ ├──────────┼──────────┼───────────────┼──────────────────┼──────────┤ │░░░░
░░░│ │ 12/08/92 │ BEGENT │ 300.00 │ $25.0000 │ Begin │ │░░░░
░░░│ │ 12/08/92 │ 000005 │ 12.00 │ $23.7500 │ Purchase │ │░░░░
░░░│ │ 12/08/92 │ 000006 │ 3.00 │ $25.0000 │ Purchase │ │░░░░
░░░│ │ 12/08/92 │ 000007 │ 22.00 │ $23.2750 │ Purchase │ │░░░░
░░░│ │ │ │ │ │ │ │░░░░
░░░│ └──────────┴──────────┴───────────────┴──────────────────┴──────────┘ │░░░░
░░░│ Onhand QTY.: 337.00 ea Average cost: $24.8429 │░░░░
░░░└───────────────────────────────────────────────────────────────────────┘░░░░
Press F5 will pop up stock transaction record card for that item. You can
use arrow key or PgUp PgDn key to scroll through out the card. Stock card
will be cleared for every closing period according to your business inventory
cycle.
░░░┌┬──────────────────────────────────────────────────────────────────────┐░░░░
░░░├┘ S T O C K L E D G E R │░░░░
░░░├───────────────────────────────────────────────────────────────────────┤░░░░
░░░│ Item Code#: 2091-092 │░░░░
░░░│ Description: Sound Blaster │░░░░
░░░│ Group Code: ELEC │░░░░
░░░│ Group Name: Electric Appliance │░░░░
░░░│ Unit Count: ea │░░░░
░░░│ Warehouse: 23 Balance Forward: 300.00 │░░░░
░░░├──────────┬────────────┬───────────────┬───────────────┬───────────────┤░░░░
░░░│ Date │ Doc. No. │ Received │ Issued │ Balance │░░░░
░░░├──────────┼────────────┼───────────────┼───────────────┼───────────────┤░░░░
░░░│ 12/08/92 │ 000005 │ 12.00 │ 0.00 │ 312.00 │░░░░
░░░│ 12/08/92 │ 000006 │ 3.00 │ 0.00 │ 315.00 │░░░░
░░░│ 12/08/92 │ 000007 │ 22.00 │ 0.00 │ 337.00 │░░░░
░░░│ │ │ │ │ │░░░░
░░░│ │ │ │ │ │░░░░
░░░│ │ │ │ │ │░░░░
░░░└──────────┴────────────┴───────────────┴───────────────┴───────────────┘░░░░
Alt-M will pop up the memo information that relate to current inventory
item.
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░╔╤════════════════════════════════════════════════════════════════════╗░░░░░
░░░░╟┘ Inventory Database File ║░░░░░
░░░░╟──────────────┌┬─────────────────────────────────────┐───────────────╢░░░░░
░░░░║ ├┘ Memorandum │ ║░░░░░
░░░░║ Item Code├──────────────────────────────────────┤ ║░░░░░
░░░░║ Descriptio│ Ingredient for Cookies │ ║░░░░░
░░░░║ Group Cod│ │ ║░░░░░
░░░░║ Group Nam│ Flour 20 Oz │ ║░░░░░
░░░░║ Unit Coun│ Libroflavin 15 Oz │ ║░░░░░
░░░░║ Cost/Uni│ Choco Chips 25 Oz │ $1.20 ║░░░░░
░░░░║ Minimum QTY│ Buttermil 10 Oz │ 0.00 ║░░░░░
░░░░║ Beginning QTY│ Caramel 30 Oz │ $22.50 ║░░░░░
░░░░║ Onhand QTY│ Does not meet US Daily Requirement │ $128.25 ║░░░░░
░░░░║ Warehous└──────────────────────────────────────┘ ║░░░░░
░░░░║ ┌╢░░░░░
░░░░╚════════════════════════════════════════════════════════════════════╧╝░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
Press ESC twices to walk back to the main pull down menu.
Besides inventory, Database selection also has other areas that keeps
permanent data in a file. These area includes: Group/Categories, Customer and
Vendors which has the same easy to use traveling menu. It is not so necessary
to enter all the information at this moment as we will show you later in this
manual.
≡ Database Transaction Process Report Setup Quit
░░░░░░┌──────────────────┐░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░│ Inventory │░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░│ Group/Categories │░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░├──────────────────┤░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░│ Customer │░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░│ Vendor/Supplier │░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░└──────────────────┘░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
Access to inventory file
DOCUMENTARY DATABASE
With the pull down menu, select [Transaction] for documentary database
which consist of: Purchase Order, Receiving Report, Order entries....etc.
≡ Database Transaction Process Report Setup Quit
░░░░░░░░░░░░░░░░░░┌────────────────────┐░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░│ Purchase order │░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░│ Receiving report │░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░├────────────────────┤░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░│ Order entries │░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░│ Commercial invoice │░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░│ Shipment analysis │░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░└────────────────────┘░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
PURCHASE ORDERING SYSTEM AND RECEIVING REPORTS.
WRITING UP PURCHASE ORDER
Tiny lets you write up purchase order to be given to you supplier with
automatic tracking and updating your inventory when goods are actually
received.
┌─────────────────────────────────────────────────────────────────────────────┐
│ PURCHASE ORDER │
│ Vendor: P/O No.: │
│ Date: 12/09/92 │
│ Delivery: 12/09/92 │
│ Due Date: 12/09/92 │
│ Pay Terms: │
│┌───────────────┬──────────────────────────────────────────┬──────────────┬─ │
││ Item Code# │ Description │ Quantity │ │
│├───────────────┼──────────────────────────────────────────┼──────────────┼─ │
││ │ │ │ │
││ │ (Scrollable Region) │ │ │
││ │ │ │ │
││ │ │ │ │
│├───────────────┴──────────────────────────────────────────┴──────────────┴─ │
││ (ZERO DOLLARS ONLY) │
│└─────────────────────────────────────────────────────────────────────────── │
│ Sales Tax Rate: 0.00% Shipping Charge: $0.00 │
└─────────────────────────────────────────────────────────────────────────────┘
Purchase order also has traveling menu mentioned in the previous page.
WRITING UP NEW PURCHASE ORDER
Press A or select [Append] command to add new purchase order. Tiny would
request you to enter purchase order number.
P/O No:
Purchase order number will automatically increment itself from the initial
number you entered. If your starting PO number is 000301, next time around it
will be 000302 and 000303 and so on. Only number is allowed in this version
due to easier calculation.
Date:
Date field is simply the issue data for purchase order. Date value will
be pulled from the system clock in you computer.
Vendor:
Vendor field requires you to enter vendor code. If you enter non existing
vendor code, the program would request you to enter new vendor. PURCHASE
ORDER Vendor: GMC P/O No.: 000001
Date: 12/09/92 Delivery: 12/09/92 Due Date: 12/09/92 Pay Terms:
┌─────────────────────────────────────────────────────────────────────────┐
│ PURCHASE ORDER │
│ Vendor: GMC P/O No.: 000001 │
│ Date: 12/09/92 │
│ Delivery: 12/09/92 │
│ Due Date: 12/09/92 │
│ Pay Terms: │
│┌────────────┬──────────────────────────────────────────┬─────────────┬─ │
││ Item Code# ╔╤═══════════════════════════════════════╗ │ Quantity │ │
│├────────────╟┘ Verify ║─┼─────────────┼─ │
││ ╟────────────────────────────────────────╢ │ │ │
││ ║ New or non-existing code. Add new one? ║ │ │ │
││ ║ ║ │ │ │
││ ║ ┌────────╖ ┌──────────╖ ┌───────╖ ║ │ │ │
││ ║ │ INSERT ║ │ CONTINUE ║ │ ABORT ║ ║ │ │ │
││ ║ ╘════════╝ ╘══════════╝ ╘═══════╝ ║ │ │ │
││ ╚════════════════════════════════════════╝ │ │ │
│├────────────┴──────────────────────────────────────────┴─────────────┴─ │
└┴────────────────────────────────────────────────────────────────────────┘
Select INSERT or press I to add new vendor.
┌────────────────────────────────────────────────────────────────────────┐
│ PURCHASE ORDER │
│ Vendor: P/O No.: 000001 │
│ Date: 12/09/92 │
│ ╔╤═══════════════════════════════════════════════════════╗/92 │
│ ╟┘ Vendor/Suppliers Database File ║/92 │
│ ╟────────────────────────────────────────────────────────╢ │
│┌──────║ ║────┬─ │
││ Item║ Vendor Code: █ ║tity│ │
│├──────║ Vendor Name: ║────┼─ │
││ ║ Address: ║ │ │
││ ║ ║ │ │
││ ║ ║ │ │
││ ║ Tel. No.: ( ) - - , - - ║ │ │
││ ║ Fax. No.: ( ) - ║ │ │
││ ║ Contact Person: ║ │ │
││ ║ Credit: 0 days ║ │ │
│├──────║ Note: memo ║────┴─ │
││(ZERO ║ ┌╢ │
│└──────╚═══════════════════════════════════════════════════════╧╝────── │
└────────────────────────────────────────────────────────────────────────┘
Fill in vendor information and press F10 to save to disk and ESC to cancel.
You then back purchase order to continue writing.
Delivery:
Delivery is the delivery date require for purchase order. You can use
this delivery date for daily checking with [View] command.
Due Date:
Due date is the payment due date for purchase order. This date is used in
this version for index search and documentary purpose only. In the next
version, we will try to put some account payable feature with this field. Due
Date will be automatically set according to the credit field specify in the
vendor information. You can change this due date.
Payment Term:
Payment term is used for comment only. Usually you will write here "60 days"
"90 Days" or any other comment 2/10 net 30 etc.
Hit [ENTER] or [PGDN] will bring you to the detail part of purchase order.
Item Code#:
At this point you will enter item code (if you remember) or hit F2 to pick
inventory item from the list.
REMARK: HITTING F2 TO PICK FROM A LIST OF INVENTORY ITEM WOULD GIVE YOU THE
FIRST ITEM IN THE LIST. HOWEVER IF YOU REMEMBER SOME PART OF THE
ITEM CODE, SIMPLY ENTER INTIAL CODE CHARACTER AND PRESS F2 WILL
JUMP TO THE CLOSEST MATCH FOR STARTING YOUR PICK LIST.
PURCHASE ORDER
Vendor: P/O No.: 000001
Date: 12/09/92
Delivery: 12/09/92
┌──────────────────────────────────────────────────────────────────────┐
│ Item Code# Description Group Code │
┌──├──────────────────────────────────────────────────────────────────────┤───┬─
│ │ 129 Muscurelax heating pad (Electrolux) ELEC │ │
├──│ 1392-9 CASIO-CS1270 Multitread calc ELEC │───┼─
│ 1│ 1397 ............................... .... │00 │
│ │ XXXX ............................... .... │00 │
│ │ NNNNNN NNNNNNN........................ .... │ │
│ │ │ │
│ │ │ │
│ │ │ │
│ │ │ │
├──│ │───┴─
│ (└──────────────────────────────────────────────────────────────────────┘
└───────────────────────────────────────────────────────────────────────────────
While in the pick list you can:
use [PGDN] to move to the next page of pick list.
use [PGUP] to move to the previous page of pick list.
use up and down arrow key to scroll through the list.
Select the item and press [ENTER] to return to purchase order.
If you enter code that are new or non exist in the database, Tiny will
request you to add new inventory item.
PURCHASE ORDER
Vendor: P/O No.: 000001
Date: 12/09/92
Delivery: 12/09/92
Due Date: 12/09/92
Pay Terms:
┌──────────────────┬──────────────────────────────────────────┬───────────────┬─
│ Item Code# ╔╤═══════════════════════════════════════╗ │ Quantity │
├──────────────────╟┘ Verify ║─┼───────────────┼─
│ 029 ╟────────────────────────────────────────╢ │ 20.00 │
│ 230 ║ New or non-existing code. Add new one? ║ │ 0.00 │
│ ║ ║ │ │
│ ║ ┌────────╖ ┌──────────╖ ┌───────╖ ║ │ │
│ ║ │ INSERT ║ │ CONTINUE ║ │ ABORT ║ ║ │ │
│ ║ ╘════════╝ ╘══════════╝ ╘═══════╝ ║ │ │
│ ╚════════════════════════════════════════╝ │ │
├──────────────────┴──────────────────────────────────────────┴───────────────┴─
Select INSERT or press I to add new item while inside purchase order.
PURCHASE ORDER
Vendor: P/O No.: 000001
Date: 12/09/92
╔╤════════════════════════════════════════════════════════════════════╗
╟┘ Inventory Database File ║
╟─────────────────────────────────────────────────────────────────────╢
┌───║ ║───┬─
│ ║ Item Code#: ║ │
├───║ Description: ║───┼─
│ 02║ Group Code: ║00 │
│ ║ Group Name: ║00 │
│ ║ Unit Count: ║ │
│ ║ Cost/Unit: $0.00 Selling Price: $0.00 ║ │
│ ║ Minimum QTY.: 0.00 Maximum QTY.: 0.00 ║ │
│ ║ Beginning QTY.: 0.00 Beginning Value: $0.00 ║ │
│ ║ Onhand QTY.: Onhand Value: ║ │
├───║ Warehouse: Note: memo ║───┴─
│ (E║ ┌╢
└───╚════════════════════════════════════════════════════════════════════╧╝─────
Sales Tax Rate: 0.00% Shipping Charge: $0.00
You then add new inventory items, press F10 to save to disk and back
to continue with purchase order once again.
(Press F1 to get help on how to edit line item for purchase order)
┌────────────────────────────────────────────────────────────────────────────┐
│ SOMETHING YOU SHOULD KNOW ABOUT EDITING LINE ITEM │
│ If you see a cursor in any field, you are in editing mode; otherwise, │
│ you will be in walk mode. │
│ In editing mode, press Ctrl-Y would erase the entire field. │
│ In walking mode, press Ctrl-Y would erase the entire line. │
│ In walking mode, press Ctrl-N would insert new line at current line. │
└────────────────────────────────────────────────────────────────────────────┘
Description will be pulled automatically from item code.
Enter quantity you intend to purchase and hit [ENTER]
Unit is unchangable data and already enter for the line item.
Price will also be pulled from the database
Discount has three options:
■ If you enter the amount of discount without % (Percentage) sign
it will treat normally such as $5.00 $50.00 etc.
■ If you enter percentage sign such as 5% or 2%, Tiny will compute
the discount percentage and deduct the amount for you.
■ If you enter percentage sign with + in between such as 10+2+3% or
10%+2%+3%, Tiny will use multiple discount percentage. That is,
the discount will be 10% then 2% then another 3%.
Amount will be updated instantly. Hit [ENTER] again to continue
with next item line and continue as above.
OR
Hit [PGDN] to the bottom of purchase order.
You then can enter sales tax rate and shipping charge.
Press F10 to save the entire purchase order to disk.
PRINT OUT PURCHASE ORDER
Press Alt-P to print out purchase order. It print you purchase order
in landscape so you need to feed your A4 paper sideway. Make sure that
printer are ready otherwise Tiny will report printing error.
Other command for purchase order is the same as traveling menu mention
in the previous page which we will not cover here in great details.
RECEIVING REPORT
In real life, not all purchase order gets complete delivery immediately.
Usually, supplier or vendor might send merchandise to you according to your
purhase order in lot by lot quantity until completion. Thus, this require a
proper purchase order tracking, and receiving report is designed to do just
that. Your purchase order never update inventory by itself. Receiving Report
that pulls data from you purchase order does the actual update of your
inventory.
Press ESC again to bring you back to main pull down menu.
≡ Database Transaction Process Report Setup Quit
░░░░░░░░░░░░░░░░░░┌────────────────────┐░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░│ Purchase order │░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░│█Receiving█report███│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░├────────────────────┤░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░│ Order entries │░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░│ Commercial invoice │░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░│ Shipment analysis │░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░└────────────────────┘░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
Press R or select [Receiving Report] to receive goods from customer.
Append Delete Update Next Previous Top Bottom Search Order View Exit
RECEIVING REPORT
Vendor: R/R No.:
Date: 12/11/92
Vendor Code:
P/O No.:
┌──────────────────┬──────────────────────────────────────────┬───────────────┬─
│ Item Code# │ Description │ Quantity │
├──────────────────┼──────────────────────────────────────────┼───────────────┼─
│ │ │ │
│ │ │ │
│ │ │ │
│ │ │ │
├──────────────────┴──────────────────────────────────────────┴───────────────┴─
│ (ZERO DOLLARS ONLY)
└───────────────────────────────────────────────────────────────────────────────
Sales Tax Rate: 0.00% Shipping Charge: $0.00
PREPARING RECEIVING REPORT
*** IT IS NOT NECCESSARY TO HAVE PURCHASE ORDER IN ORDER TO DO A
RECEIVING REPORT. RECEIVING REPORT CAN BE WRITTEN UP AT ANYTIME WHEN
YOU WANT TO RECEIVE GOODS TO UPDATE YOUR INVENTORY ***
Receiving report can be prepared at anytime with or without the need to
write up purchase order in advance. The received quantity will update
inventory immediately when you finish and press F10.
Select [Append] command or hit "A" character to add new receiving report.
R/R No:
Receiving report number is initialized by you the the first time and
automatically increment when [Append] command.
Date:
Date will be pulled from system clock.
Vendor Code:
Vendor code can be entered immediately or press F2 to pick from the
list of available vendors.
P/O No:
If you already have purchase order written up in advance, you can press
F2 here to pick from the list of available purchase order. The pick list would
start from the beginning. In case where you know the running number of
purchase order in advance, simply write in some initial number and press F2
instead. The pick list will start from the closest match found.
Append Delete Update Next Previous Top Bottom Search Order View Exit
RECEIVING REPORT
Vendor:GARMAN & CO R/R No.: 000001
1270 SIAM CENTER SHOPPING PLAZA Date: 12/11/92
OLYMPIC AVE Vendor Code:GMC
BANGKOK 19191 THAILAND P/O No.:05
┌──────────────────┬──────────────────────────────────────────┬───────────────┬─
│ Item Cod┌─────────────────────────────────────────────────┐ Quantity │
├────────────│ P/O No. Date Vendor Code Delivery Due Date │──────────────┼─
│ ├─────────────────────────────────────────────────┤ │
│ │██052111█12/09/92██GMC█████████12/19/92█01/23/93█│ │
│ │ 053211 12/09/92 DANIEL 12/22/92 01/29/93 │ │
│ │ │ │
│ │ │ │
│ │ │ │
├────────────│ │──────────────┴─
│ (ZERO DOLLA└─────────────────────────────────────────────────┘
└───────────────────────────────────────────────────────────────────────────────
The entire purchase order will be pulled into receiving report.
RECEIVING REPORT
Vendor:GARMAN & CO R/R No.: 000001
1270 SIAM CENTER SHOPPING PLAZA Date: 12/11/92
OLYMPIC AVE Vendor Code:GMC
BANGKOK 19191 THAILAND P/O No.:05
┌──────────────────┬──────────────────────────────────────────┬───────────────┬─
│ Item Code# │ Description │ Quantity │
├──────────────────┼──────────────────────────────────────────┼───────────────┼─
│019-020202 │PRODUCT XXXXX │ 300.00 │
│019-012111 │PRODUCT BBBBBB │ 20.00 │
│......... │............................... │ │
│......... │.............................. │ │
│ │ │ │
├──────────────────┴──────────────────────────────────────────┴───────────────┴─
│ (ZERO DOLLARS ONLY)
└───────────────────────────────────────────────────────────────────────────────
At this moment, you can:
1) Uses -> <- key to move around the invoice body.
2) Change the quantity of actual receiving goods.
or
3) Press Ctrl-Y (Walkmode) to delete the item line not received.
4) Press Ctrl-N (Walkmode) to insert the item line.
5) Press F2 in item code# column to add new item to receiving report
using the pick list.
When finish, press F10 to update inventory and purchase order status.
Notice the processing window will appear every time there is transaction
update.
NOTICE: When receiving report updates inventory, it also updates the
corresponding purchase order. The original ordered quantity in
purchase order remains unchange. However, next time when you select
in the same purchase order into your receiving report, only the
remaining balance of purchase order will be pulled into your
receiving report.
Press Alt-P to print out receiving report. Make sure that printer are
ready otherwise Tiny will report printing error. Receiving report are
usually given to your customer for reference.
Press ESC to go back to the main pull down menu.
≡ Database Transaction Process Report Setup Quit
░░░░░░░░░░░░░░░░░░┌────────────────────┐░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░│ Purchase order │░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░│ Receiving report │░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░├────────────────────┤░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░│█Order█entries██████│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░│ Commercial invoice │░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░│ Shipment analysis │░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░└────────────────────┘░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
Select Order entries or press "O" to get into order entries file.
COMMERCIAL INVOICING AND ORDER ENTRIES.
ORDER ENTRIES (ENTER CUSTOMER BOOKING IN ADVANCE)
Order entries allows you to enter your customer pre-order or booking of
merchandise in advance. When ready, you can do some shipment analysis or move
order entries data into your commercial invoice.
Select [Append] or "A" to add new order entries.
Date:
Date in order entries is obtained from the system. This suppose to be
the date where your customer called in and place order.
ORDER ENTRIES
Customer: Date: 12/12/92
Tel. No.: Customer Code:█
Contact: P/O No.:
Credit: 0 days Delivery: 12/12/92
Due In: F Note: memo
┌──────────────────┬──────────────────────────────────────────┬───────────────┬─
│ Item Code# │ Description │ Order QTY. │
├──────────────────┼──────────────────────────────────────────┼───────────────┼─
│ │ │ │
│ │ │ │
│ │ │ │
│ │ │ │
│ │ │ │
└──────────────────┴──────────────────────────────────────────┴───────────────┴─
At this point you have two options.
Press F2 to select existing customer from the pick list and hit Enter
OR
If you enter customer code that are not yet exist in the database, Tiny
would request you to add new customer.
ORDER ENTRIES
Customer: Date: 12/12/92
Tel. No.: Customer Code: SHOSYS
Conta╔╤═══════════════════════════════════════════════════════════╗
Cred╟┘ Customer Database File ║/92
Due ╟────────────────────────────────────────────────────────────╢
┌────────║ ║───────┬─
│ Item║ Customer Code: SHOSYS ║ QTY. │
├────────║ Customer Name: Sherman Audio System ║───────┼─
│ ║ Address: 129 South Veriba ║ │
│ ║ Saopa Medical Road ║ │
│ ║ Bangkok 44344 ║ │
│ ║ Tel. No.: (123) 123-4123-41, 234-1234-32 ║ │
│ ║ Fax. No.: (123) 412-3433 ║ │
│ ║ Contact Person: Sherman Kuo ║ │
│ ║ Credit: 45 days ║ │
│ ║ Note: memo ║ │
│ ║ ┌╢ │
│ ╚═══════════════════════════════════════════════════════════╧╝ │
└──────────────────┴──────────────────────────────────────────┴───────────────┴─
Press F10 to save customer data to disk and back to continue with order
entries.
The program will jump to item code. Press F2 to select from the
availble list of inventory items and hit [ENTER].
ORDER ENTRIES
Customer: Sabatiny Powder company Date: 12/19/92
Tel. No.: (234) 523-45 - , - - Customer Code: 09-09
Contact: jeff Batel P/O No.: 12121
┌──────────────────────────────────────────────────────────────────────┐
│ Item Code# Description Group Code │
┌──├──────────────────────────────────────────────────────────────────────┤───┬─
│ │ 0129 Chocho Chips Cookies SNACKS │. │
├──│ 0130 AUNT JAMAIMA LIGHT COOKIES MIX SNACKS │───┼─
│ │ 0132 Coffee Warmer (ElectroLux) ELX-1208P ELEC │00 │
│ │ 2091-092 Sound Blaster ELEC │ │
│ │ EC1276 Electric Calculator 1276 (Texas Inst) ELEC │ │
│ │ │ │
│ │ │ │
│ └──────────────────────────────────────────────────────────────────────┘ │
└──────────────────┴──────────────────────────────────────────┴───────────────┴─
Description will be automatically pulled from the list.
You then enter the quantity that customer want to book in advance.
┌──────────────────┬──────────────────────────────────────────┬───────────────┬─
│ Item Code# │ Description │ Order QTY. │
├──────────────────┼──────────────────────────────────────────┼───────────────┼─
│ 0129 │ Chocho Chips Cookies │ 0.00 │
│ │ │ │
│ │ │ │
└──────────────────┴──────────────────────────────────────────┴───────────────┴─
Unit is unchangable at this time and will be pulled from the list including
price per unit. You can also change the order quantity and price to reflect
the order of your customer.
────────────────────────────┬───────────────┬─────────────────┬────────────────┬
Description │ Order QTY. │ Unit │ Order Price │
────────────────────────────┼───────────────┼─────────────────┼────────────────┼
Cookies │ 0.00 │ EA │ $1.20 │
│ │ │ │
│ │ │ │
│ │ │ │
────────────────────────────┴───────────────┴─────────────────┴────────────────┴
Shipped QTY and Balance quantity should be zero at this time. You can not
change the amount as TINY will use this field to update the delivery balance
for you at the time you issue commercial invoice.
Repeat adding items until you satisfied and press F10 to save order entries
to disk.
────────────┬───────────────┬─────────────────┬────────────────┬───────────────┬
│ Order QTY. │ Unit │ Order Price │ Shipped QTY. │
────────────┼───────────────┼─────────────────┼────────────────┼───────────────┼
│ 0.00 │ EA │ $1.20 │ 0.00 │
│ │ │ │ │
│ │ │ │ │
────────────┴───────────────┴─────────────────┴────────────────┴───────────────┴
────────────┬─────────────────┬────────────────┬───────────────┬───────────────┐
Order QTY. │ Unit │ Order Price │ Shipped QTY. │ Balance │
────────────┼─────────────────┼────────────────┼───────────────┼───────────────┤
0.00 │ EA │ $1.20 │ 0.00 │ 0.00 │
│ │ │ │ │
│ │ │ │ │
────────────┴─────────────────┴────────────────┴───────────────┴───────────────┘
SHIPMENT ANALYSIS (PRODUCTS AND CUSTOMERS MATCHING GAME)
Tiny allows you to do shipment analysis base on your customer order against
your inventory. This feature lets you see how much quantity do you need to
back order or replenish your inventory, even help you prepare to meet the
demanding customer orders. Various customer might want the same product and
place order to you in advance. So you need to manage when to send, how much to
send, which customer should get it first...etc.
Press ESC to get back to main, pull down menu.
≡ Database Transaction Process Report Setup Quit
░░░░░░░░░░░░░░░░░░┌────────────────────┐░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░│ Purchase order │░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░│ Receiving report │░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░├────────────────────┤░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░│ Order entries │░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░│ Commercial invoice │░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░│█Shipment█analysis██│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░└────────────────────┘░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
Select [Shipment analysis] option or hit "S" to get into shipment analysis
file.
Append Delete Update Next Previous Top Bottom Search Order View Exit
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░╔╤══════════════════════════════════════════════════════════════════════╗░░░░
░░░╟┘ Shipment Analysis ║░░░░
░░░╟───────────────────────────────────────────────────────────────────────╢░░░░
░░░║ Item Code#: 0129 ║░░░░
░░░║ Description: Chocho Chips Cookies ║░░░░
░░░║ Group Code: SNACKS ║░░░░
░░░║ Group Name: SNACKS ITEM ║░░░░
░░░║ Onhand: 176.00 EA ║░░░░
░░░║┌────────────┬───────────────┬─────────────────────────────────────────║░░░░
░░░║│ Order Date │ Customer Code │ Customer Name ║░░░░
░░░║├────────────┼───────────────┼─────────────────────────────────────────║░░░░
░░░║│ │ │ ║░░░░
░░░║│ │ │ ║░░░░
░░░║│ │ │ ║░░░░
░░░║└────────────┴───────────────┴─────────────────────────────────────────║░░░░
░░░╚═══════════════════════════════════════════════════════════════════════╝░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
You can not append data to shipment analysis file because all off the
data already exist and are available from order entries file.
Shipment analysis shows you:
1) When customer place the order ?
2) How many customers have place order on a single product ?
3) The booking price that customer have placed on the product.
4) The customer purchase order number P/O No. (not yours).
5) How much quantity do you need to prepare to be able to satisfy all
customers order for a single product ?
6) How much has already been shipped to each customer ?.
7) What is the shipment balance left for each customer ?.
You can not change this information directly unless you change the data in the
order entries file. However, this file just let you browse through it only. To
browse data inside shipment analysis file, select [Update] option or press
"U". The lightbar will be moved into the display columns. You then can:
Press <- or -> arrow key to move left and right between columns.
Press [PgDn] [PgUp] key to move to next inventory items.
Press [ESC] to get out to traveling menu. (All other commands in traveling
menu remains the same as mention in the previous pages).
COMMERCIAL INVOICE
When you are ready to send goods to customer, you can issue invoice by
writing it up or pulled it directly from the customer order entries file.
Press ESC again to walk back to the main, pull down menu.
≡ Database Transaction Process Report Setup Quit
░░░░░░░░░░░░░░░░░░┌────────────────────┐░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░│ Purchase order │░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░│ Receiving report │░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░├────────────────────┤░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░│ Order entries │░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░│█Commercial█invoice█│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░│ Shipment analysis │░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░└────────────────────┘░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
Select [Commercial invoice] or press "C" to jump into commercial invoice file.
Append Delete Update Next Previous Top Bottom Search Order View Exit
DELIVERY ORDER
Customer: D/O No.: 000003
Date: 12/22/92
Customer Code:
Due Date: 12/22/92
Pay Terms:
Salesman: P/O No.:
┌──────────────────┬──────────────────────────────────────────┬───────────────┬─
│ Item Code# │ Description │ Quantity │
├──────────────────┼──────────────────────────────────────────┼───────────────┼─
│ │ │ │
│ │ │ │
│ │ │ │
│ │ │ │
│ │ │ │
│ │ │ │
├──────────────────┴──────────────────────────────────────────┴───────────────┴─
│ (ZERO DOLLARS ONLY)
└───────────────────────────────────────────────────────────────────────────────
Sales Tax Rate: 0.00% Shipping Charge: $0.00
F1:Help F2:Pick List F3:Booking F4:Analysis F10:Confirm Esc:Cancel Alt-P:Print
ADDING NEW INVOICE (DELIVERY ORDER)
You can write-up invoice to any customer at any time or pull the
delivery schedule directly from the order entries file.
Select [Append] or press "A" to add new invoice. The D/O No. or invoice
number will be automatically increment from the number you specify. You can
change this number at anytime and the number would self-increase next time you
append additional invoice.
Date:
Date is the date for issuing invoice and is obtained from the system clock.
Customer Code:
You have two options here:
Press F2 to select from the list of available customer.
or
Enter new customer code. Tiny would request you to enter new customer
in the database file then pop you back to continue with your invoice.
Due Date:
Due date is the date to pay for this invoice. Due date are automatically
compute base on credit given to each customer.
Pay Terms:
You can enter anything at this field.
P/O No:
These field has following options:
Press F2 at this field will pop up a list of available delivery order.
Customer Code:
Due Date: 12/22/92
Pay Terms:
Salesman: ┌────────────────────────────────────────────────┐:
┌─────────────│ Date Customer Code P/O No. Delivery Due In │──────────────┬─
│ Item Code├────────────────────────────────────────────────┤ Quantity │
├─────────────│█12/22/92██09-09█████████122767█12/22/92████T███│──────────────┼─
│ │ 12/28/92 02-19 372187 12/22/92 T │ │
│ │ 12/28/92 08-39 523487 12/22/92 T │ │
│ │ 12/28/92 02-59 342124 12/22/92 T │ │
│ │ 12/28/92 02-69 272187 12/22/92 T │ │
│ │ 12/28/92 06-79 172287 12/22/92 F │ │
│ │ 12/28/92 02-99 232187 12/22/92 T │ │
├─────────────│ │──────────────┴─
│ (ZERO DOLLAR└────────────────────────────────────────────────┘
└───────────────────────────────────────────────────────────────────────────────
You can use arrow keys or [PgUp] [PgDn] key to browse from the list of
customer booking schedule and the hit enter to select the delivery order you
want to shove into your invoice. The column "Due In" with "T" in the column
shows you that the order booking from customer still active and needs to be
delivered.
With in the invoice body, you can:
1) Use <- -> arrow keys to move between columns.
2) Change the price of line item in the invoice.
3) Change the quantity of line item in the invoice.
4) Press Ctrl-N to insert new line item inside the invoice body.
5) Press Ctrl-Y to delete line item.
6) Press F2 at item code column to pop-up and select from inventory list.
7) Press [PgDn] to change tax rate and shipping charge then hit [PgUp] to
back at invoice body. When ready press F10 to save the entire invoice
to disk.
Delivery order also update the balances of your customer booking so the
next time only the balance to be shipped will be pulled into your up-coming
invoice.
DOMINO EFFECT
Tiny Master maintains data compatibility between files;therefore ,a change
in one database file automatically changes related database file. For example:
A change in an already-updated invoice's quantity automatically reupdate the
inventory status. A change or correction in purchase order quantity also
updates receiving reports and inventory status...etc.
CRANK OUT YOUR REPORTS
Tiny comes with eleven reports with variety of printing options. In future
version, we will throw in some more extra report programs base on customer's
fax-in request. At this time, we tries to make the program smaller to make
initial shareware distribution easy.
≡ Database Transaction Process Report Setup Quit
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░┌─────────────────────┐░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│ Inventory listing │░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│ Dead-stock listing │░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│ Reorder listing │░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│ Overstock listing │░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│ Price list │░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░├─────────────────────┤░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│ Physical inventory │░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│ Inventory valuation │░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│ Yearly summary │░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░├─────────────────────┤░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│ Receiving │░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│ Sales/Distribution │░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│ Outstanding order │░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░└─────────────────────┘░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
Print out onhand quantity INSERT
≡ Database Transaction Process Report Setup Quit
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░┌─────────────────────┐░░░░░░░░░░░░░
░░┌──────────────────────┐░░░░░░░░░░░░░░░░░░│ Inventory listing │░░░░░░░░░░░░░
░░│ Order by item code# │░░░░░░░░░░░░░░░░░░│ Dead-stock listing │░░░░░░░░░░░░░
░░│ Order by description │░░░░░░░░░░░░░░░░░░│ Reorder listing │░░░░░░░░░░░░░
░░│ Order by group code │░░░░░░░░░░░░░░░░░░│ Overstock listing │░░░░░░░░░░░░░
░░│ Order by warehouse │░░░░░░░░░░░░░░░░░░│ Price list │░░░░░░░░░░░░░
░░└──────────────────────┘░░░░░░░░░░░░░░░░░░├─────────────────────┤░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│ Physical inventory │░░░░░░░░░░░░░
░░┌─────────────────────────┐░░░░░░░░░░░░░░░│ Inventory valuation │░░░░░░░░░░░░░
░░│ Entire database report │░░░░░░░░░░░░░░░│ Yearly summary │░░░░░░░░░░░░░
░░│ Partial database report │░░░░░░░░░░░░░░░├─────────────────────┤░░░░░░░░░░░░░
░░└─────────────────────────┘░░░░░░░░░░░░░░░│ Receiving │░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│ Sales/Distribution │░░░░░░░░░░░░░
░░╔╤══════════════════════════╗░░░░░░░░░░░░░│ Outstanding order │░░░░░░░░░░░░░
░░╟┘ Define Scope ║░░░░░░░░░░░░░└─────────────────────┘░░░░░░░░░░░░░
░░║ Begin: ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░║ End: ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░╚═══════════════════════════╝░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
Reports lets you sort by item code#, description, group code, warehouse or
any other key. If you select "Entire database report" all items will be
printed. However, if you select "Partial database report", you will be prompt
with Define Scope window.
You then press F2 to select from the list.
≡ Database Transaction Process Report Setup Quit
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░┌─────────────────────┐░░░░░░░░░░░░░
░░┌──────────────────────┐░░░░░░░░░░░░░░░░░░│ Inventory listing │░░░░░░░░░░░░░
░░│ Order by item code# │░░░░░░░░░░░░░░░░░░│ Dead-stock listing │░░░░░░░░░░░░░
░░│ Order by description │░░░░░░░░░░░░░░░░░░│ Reorder listing │░░░░░░░░░░░░░
░░│┌──────────────────────────────────────────────────────────────────────┐░░░░░
░░││ Item Code# Description Group Code │░░░░░
░░└├──────────────────────────────────────────────────────────────────────┤░░░░░
░░░│█0129█████████████Chocho Chips Cookies█████████████████████SNACKS█████│░░░░░
░░░│ 0130 AUNT JAMAIMA LIGHT COOKIES MIX SNACKS │░░░░░
░░┌│ 0132 Coffee Warmer (ElectroLux) ELX-1208P ELEC │░░░░░
░░││ 2091-092 Sound Blaster ELEC │░░░░░
░░││ EC1276 Electric Calculator 1276 (Texas Inst) ELEC │░░░░░
░░└│ │░░░░░
░░░│ │░░░░░
░░░│ │░░░░░
░░╔│ │░░░░░
░░╟│ │░░░░░
░░║└──────────────────────────────────────────────────────────────────────┘░░░░░
░░║ Begin: ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░║ End: ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░╚═══════════════════════════╝░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
Most of the reports would require a long carriage, 132-column printer. So
you might need to select a couple of items for print testing before try to
send the your entire inventory to printers. The program send Epson compatible
code to your printer. Some of the report has fix option and would immediately
goes to printer.
PROCESS END OF PERIOD DATA
END OF PERIOD
Tiny never knows about time frame, but you do. It maintains inventory
statistics for unlimited periods. Therefore, you can close your inventory per
period according to your company accounting cycle: daily, weekly, monthly,
semi-quarter, quarter, half-year or even yearly. Tiny keeps this period as
numbers. If you close down your inventory every month, you would have a total
of 12 periods per year. For weekly close down, you will have 52 periods per
year. You can print "Yearly summary" report to get all the statistics of the
entire year.
***** REMEMBER ******
IT IS ESSENTIAL TO PRINT ALL YOUR REQUIRE INVENTORY REPORTS BEFORE CLOSING
YOUR INVENTORY ACCOUNT TO THE NEXT INVENTORY PERIOD.
≡ Database Transaction Process Report Setup Quit
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░┌───────────────────────┐░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│ End of period │░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│█Year-end closing██████│░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│ Transaction clearance │░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░└───────────────────────┘░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░╔╤══════════════════════════════╗░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░╟┘ End of Period Process ║░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░╟───────────────────────────────╢░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░║ Do you want to continue? ║░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░║ ┌──────────╖ ┌───────╖ ║░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░║ │ CONTINUE ║ │ ABORT ║ ║░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░║ ╘══════════╝ ╘═══════╝ ║░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░╚═══════════════════════════════╝░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
Perform inventory closing for selected period CAPS INSERT
Select [End of period] to close down your inventory. You will need to confirm
and reconfirm to allow such task.
YEAR-END CLOSING
At the end of the year (after closing down last inventory period), you will
also need to select [Year-end closing] option. *** DON'T FORGET TO PRINT OUT
ALL THE REPORTS FOR THE LAST PERIOD BEFORE USING ANY OF THIS COMMAND.****
[Year-end closing] option will erase all information collected on each
inventory period and blank it for the next year. All inventory data status
will also moved to beginning of next year.
≡ Database Transaction Process Report Setup Quit
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░┌───────────────────────┐░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│ End of period │░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│█Year-end closing██████│░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│ Transaction clearance │░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░└───────────────────────┘░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░╔╤══════════════════════════════╗░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░╟┘ Year-end Process ║░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░╟───────────────────────────────╢░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░║ Do you want to continue? ║░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░║ ┌──────────╖ ┌───────╖ ║░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░║ │ CONTINUE ║ │ ABORT ║ ║░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░║ ╘══════════╝ ╘═══════╝ ║░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░╚═══════════════════════════════╝░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
Perform inventory closing for end of year CAPS INSERT
TRANSACTION CLEARANCE
Sometime you will also need to select [Transaction clearance] to wash out
all purchase orders, commercial invoices, order entries that you no longer
need. Please make sure that you have finished all these documents before
washing them out. The program will let you specify date range to clear out all
these documents followed by confirmation before continue. Washing away these
old unused documents would give you more disk space for other usage.
≡ Database Transaction Process Report Setup Quit
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░┌───────────────────────┐░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│ End of period │░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│ Year-end closing │░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│█Transaction█clearance█│░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░└───────────────────────┘░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░╔╤════════════════════════╗░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░╟┘ Specify Period ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░║ ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░║ From Date: 12/23/92 ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░║ To Date: 12/23/92 ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░╚═════════════════════════╝░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
Erase unused record in transaction files CAPS INSERT
POP-UP CALCULATOR
You computer is a heck more complicate than a calculator. How rediculous
it is to reach for a calculator when you really got one ? Press Alt-C at any
time to pop-up a calculator. This calculator had all the features of a
standard CASIO-CS1700 (cheapest) at Kmart store. It has memory saving
features, factorial, square roots...etc. and the like. Turn on scrollock key
and you can move the calculator around the screen or ESC to put it out.
HERE IS THE LIST OF KEYS THAT CAN BE USED TO EMULATE SUCH CALCULATOR.
PRESS E TO CORRECT LAST ENTRY NUMBER. PREVIOUS CALCULATION REMAINS FOR
FURTHUR CALCULATION
IF YOU PRESS WRONG CALCULATION SIGN SUCH AS +(ADD) -(MINUS) * (MULTIPLY)
OR / (DIVIDE), YOU CAN ENTER (+ - * /) NEW SIGN TO OVERRIDE PREVIOUS SIGN.
(THIS IS THE THING NOT SO COMMON IN ANY HUMAN FAMILIAR CALCULATOR)
PRESS C TO CLEAR ALL ENTRIES AND PREVIOUS CALCULATION RESULT AND TO START
OVER START AGAIN
PRESS <- (BACKSPACE) KEY TO CORRECT LAST NUMERIC NUMBER.
PRESS M AND + TO LAST CALCULATED NUMBER KEEP IN MEMORY.
PRESS M AND R TO RECALLED LAST NUMBER IN MEMORY
DOS SHELL (GET OUT TO DOS AND BACK)
Sometimes you might need to get out to Dos temporarily to do some other
task such as copy files, delete files, format disk. Thus, you can select OS
Shell option or press "O".
Database Transaction Process Report Setup Quit
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░┌─────────────┐░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│ Exit to DOS │░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│█OS shell████│░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░└─────────────┘░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
Operating system (DOS) shell
You then will then go out to DOS to do other task. When finish type EXIT to
return to TINY again. During OS shell command you can not call other program
such as Lotus 1-2-3 or Wordstar as it occupies memory larger than Dos program
and Tiny has not yet terminate.
┌────────────────────────────────────────────────────────────────┐
│ │
│ │
│Type EXIT to return to Tiny Master. . . │
│ │
│Microsoft(R) MS-DOS(R) Version 4.01 │
│ (C)Copyright Microsoft Corp 1981-1988 │
│ │
│B>EXIT │
│ │
│ │
│ │
└────────────────────────────────────────────────────────────────┘
PRINT OUT REGISTRATION FORM
≡ Database Transaction Process Report Setup Quit
░┌──────────┐░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░│ About... │░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░│█Register█│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░└──────────┘░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
If you would like to register your copy of Tiny Master, select ≡ option and
select the [Register] option. Tiny will send the registration form to printer.
Simply fill out the registration form and send to get on update list of users.
KNOWS YOUR DATA
At run time, Tiny master would create this following related data files
for your system. You can backup these files as often as you like by using
normal "copy" command from DOS prompt. You can even use file compression utility
such as PKLITE, PKZIP, LHARC to pack these files into a single disk.
CUSTOMER.MST - File for your customer record
GROUP.MST - Group information about your inventory
PRODUCT.MST - Your inventory master file.
STKCARD.MST - Stock Card information for your inventory
VENDOR.MST - File of your vendors and suppliers record
INVOICE.TRN - File for your invoice billing
ORDER.TRN - File contains outstanding order from your customer
PURCHASE.TRN - Purchase order file
RECEIVE.TRN - Receiving report file
SUMMARY.DAT - Yearly collection of your inventory statistics
MEMO.DAT - Memorandum for each inventory item.
ONE LAST WORD
Thank you for using Tiny Master. In future, we will try to improve and
pack more features into the program according to users' request. Hope that you
enjoy using Tiny Master as much as we enjoy writing it.